SQL Excel Concatenate into INSERT Command


=CONCATENATE("    ('",A2,"', '",B2,"', '",C2,"', '",D2,"', '",E2,"',", 
      "'" ,F2, "',",
      "'" ,G2, "',",
      "'" ,H2, "',",
      "'" ,I2, "',",
      "'" ,J2, "',",
      "'" ,K2, "',",
      "'" ,L2, "',",
      "'" ,M2, "',",
      "'" ,N2, "',",
      "'" ,O2, "',",
      "'" ,P2, "',",
      "'" ,Q2, "',",
      "'" ,R2, "',",
      "'" ,S2, "'",

      ")")
#SQL






你可能感興趣的文章

D11_JS101 綜合題目練習 Lv1

D11_JS101 綜合題目練習 Lv1

Web 資訊安全(Security)簡明入門教學指南

Web 資訊安全(Security)簡明入門教學指南

DEC 14 2023 PROCL-5: User does not have permission to perform a local registry operation on this key. Authentication error [User [root] [已解決]

DEC 14 2023 PROCL-5: User does not have permission to perform a local registry operation on this key. Authentication error [User [root] [已解決]






留言討論